import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * 原生接口
 * 直接使用jdb连接数据库
 */
public class Main {

    public static final String URL = "jdbc:mysql://192.168.8.166:3306/zksy";
    public static final String USER = "root";
    public static final String PASSWORD = "abc123456";

    public static void main(String[] args) throws Exception {
        // 1.加载驱动程序
        Class.forName("com.mysql.jdbc.Driver");
        // 2. 获得数据库连接
        Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
        // 3.操作数据库，实现增删改查
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM user");
        // 如果有数据，rs.next()返回true
        while (rs.next()) {
            System.out.println(rs.getString("nickname") + " email：");
        }
    }
}